Huis Verkennen Help
Registreer Inloggen
J1X
/
huginn
Volgen 2
Ster 0
Vork 0

Bladeren bron
Fixes rename_digest_email_to_email_digest migration for PostgreSQL

PostgreSQL uses double quotes to quote columns and expects strings to be
quoted with single quotes. Single quoted strings work both for MySQL and
PostgreSQL.

Dominik Sander 10 jaren geleden
bovenliggende
21e95aef41
commit
b072350746
1 gewijzigde bestanden met toevoegingen van 4 en 4 verwijderingen
Toon Diff Stats
  1. 4 4
      db/migrate/20140603104211_rename_digest_email_to_email_digest.rb

+ 4 - 4
db/migrate/20140603104211_rename_digest_email_to_email_digest.rb
Bestand weergeven 

@@ -2,8 +2,8 @@ class RenameDigestEmailToEmailDigest < ActiveRecord::Migration
2 2 
   def up
3 3 
     sql = <<-SQL
4 4 
       UPDATE #{ActiveRecord::Base.connection.quote_table_name('agents')}
5 
-      SET #{ActiveRecord::Base.connection.quote_column_name('type')} = "Agents::EmailDigestAgent"
6 
-      WHERE #{ActiveRecord::Base.connection.quote_column_name('type')} = "Agents::DigestEmailAgent"
5 
+      SET #{ActiveRecord::Base.connection.quote_column_name('type')} = 'Agents::EmailDigestAgent'
6 
+      WHERE #{ActiveRecord::Base.connection.quote_column_name('type')} = 'Agents::DigestEmailAgent'
7 7 
     SQL
8 8
9 9 
     execute sql
 
@@ -12,8 +12,8 @@ class RenameDigestEmailToEmailDigest < ActiveRecord::Migration
12 12 
   def down
13 13 
     sql = <<-SQL
14 14 
       UPDATE #{ActiveRecord::Base.connection.quote_table_name('agents')}
15 
-      SET #{ActiveRecord::Base.connection.quote_column_name('type')} = "Agents::DigestEmailAgent"
16 
-      WHERE #{ActiveRecord::Base.connection.quote_column_name('type')} = "Agents::EmailDigestAgent"
15 
+      SET #{ActiveRecord::Base.connection.quote_column_name('type')} = 'Agents::DigestEmailAgent'
16 
+      WHERE #{ActiveRecord::Base.connection.quote_column_name('type')} = 'Agents::EmailDigestAgent'
17 17 
     SQL
18 18
19 19 
     execute sql